-- @owner: @zou_jialiang050
-- @date: 2022/09/15
-- @testpoint: show create function指定触发器函数

--step1:创建表及函数;expect:成功
drop table if exists t_show_create_function_0004;
create table t_show_create_function_0004(c1 int,c2 int,c3 int);

drop function if exists f_show_create_function_0004;
create or replace function f_show_create_function_0004() returns trigger as
$$
declare
begin
    insert into t_show_create_function_0004 values(new.id1, new.id2, new.id3);
    return new;
end
$$ language plpgsql;
/

--step2:show create function指定触发器函数;expect:成功
show create function f_show_create_function_0004;

--step3:清理环境;expect:成功
drop function if exists f_show_create_function_0004;
drop table if exists t_show_create_function_0004;
